﻿using System;

namespace edowork.com.Model
{
    #region Library_adj_detailInfo

    [Serializable]
    public class Library_adj_detailInfo
    {
        #region Private fields

        protected string _ljid = String.Empty;
        protected string _areaid_out = String.Empty;
        protected string _storageid_out = String.Empty;
        protected string _areaid_in = String.Empty;
        protected string _storageid_in = String.Empty;
        protected string _productcode = String.Empty;
        protected decimal _qty;

        #endregion

        public Library_adj_detailInfo() { }

        #region Public Properties

        public string Ljid
        {
            get { return _ljid; }
            set { _ljid = value; }
        }

        public string Areaid_out
        {
            get { return _areaid_out; }
            set { _areaid_out = value; }
        }

        public string Storageid_out
        {
            get { return _storageid_out; }
            set { _storageid_out = value; }
        }

        public string Areaid_in
        {
            get { return _areaid_in; }
            set { _areaid_in = value; }
        }

        public string Storageid_in
        {
            get { return _storageid_in; }
            set { _storageid_in = value; }
        }

        public string Productcode
        {
            get { return _productcode; }
            set { _productcode = value; }
        }

        public decimal Qty
        {
            get { return _qty; }
            set { _qty = value; }
        }

        #endregion

        #region Public SQL Insert Script

        public string SQL_Insert()
        {
            return "insert into Library_adj_detail(Ljid,Areaid_out,Storageid_out,Areaid_in,Storageid_in,Productcode,Qty) values('{0}','{1}','{2}','{3}','{4}','{5}',{6})";
        }

        #endregion

    }

    #endregion
}

